<?php

	$dir = pathinfo($_SERVER['SCRIPT_FILENAME']); 

	if (ini_set("include_path",ini_get("include_path").((strtoupper(PHP_OS) == "LINUX") ? ":" : ";").$dir['dirname']) === false) {
		echo "ERROR: Definicion en el include_path";
		exit;
	}

	include('../adodb/adodb.inc.php');
	include_once('../adodb/adodb-pager.inc.php');
    include_once('../conf/dbconn_param.php');
	
	
	$db = ADONewConnection($dbdriver);
	$db->Connect($server, $user, $password, $database);
	$db->SetFetchMode(ADODB_FETCH_ASSOC);

    $db->debug = false;
	
	$sql = 'select * from subtema where tema = '.$_REQUEST['tema'];
    $rs = $db->Execute($sql);
    $datos = $rs->GetRows();
	
	
	$i = 0;
	
	foreach($datos as $data_) {
               $id = trim($data_['pk_subtema']);
               echo "<option value=\"$id\">".utf8_encode($data_['descripcion'])."</option>";
           }
	 $db->Close;
?>	